using IronXL;
using System;
using System.Data;
// Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
WorkBook workBook = WorkBook.Load("sample.xlsx");
// Select default sheet
WorkSheet workSheet = workBook.DefaultWorkSheet;
// Convert the worksheet to DataTable
DataTable dataTable = workSheet.ToDataTable(true);
// Enumerate by rows or columns first at your preference
foreach (DataRow row in dataTable.Rows)
{
for (int i = 0 ; i < dataTable.Columns.Count ; i++)
{
Console.Write(row[i]);
}
}
Imports IronXL
Imports System
Imports System.Data
' Supported for XLSX, XLS, XLSM, XLTX, CSV and TSV
Private workBook As WorkBook = WorkBook.Load("sample.xlsx")
' Select default sheet
Private workSheet As WorkSheet = workBook.DefaultWorkSheet
' Convert the worksheet to DataTable
Private dataTable As DataTable = workSheet.ToDataTable(True)
' Enumerate by rows or columns first at your preference
For Each row As DataRow In dataTable.Rows
For i As Integer = 0 To dataTable.Columns.Count - 1
Console.Write(row(i))
Next i
Next row
Install-Package IronXL.Excel
DataTable을 통해 Excel에서 SQL 및 DataGrid로 데이터 전송
완전한 상호 운용성을 위해 System.Data.SQL와 함께 또는 DataGrid을 채우기 위해 XLSX, XLS, XLSM, XLTX, CSV 및 TSV 파일을 System.Data.DataTable로 변환합니다.
테이블의 첫 번째 행을 열 이름으로 설정하려면 ToDataTable 메서드에 true을 입력하세요. DataTable는 DataGrid을 채울 수 있습니다.